home *** CD-ROM | disk | FTP | other *** search
- After OPTIMIZATION, Best Answer‚Ñ¢ can display the amount
-
- each ADJUSTABLE cell is contributing to the value of the objective
-
- formula (e.g. profit per unit). This amount is not always obvious.
-
-
-
- The information is provided as a "Contribution Range", within
-
- which the contribution may vary without affecting the optimal
-
- solution. This range allows you to estimate the degree of confi-
-
- dence you have in the optimal solution.
-
-
-
- Consider the Product Mix example. Once you have optimized the
-
- model, the contribution range for the adjustable "Summer Sausage"
-
- indicates a range of $1.20 to $1.70. This means that the profit per
-
- unit of "Summer Sausage" can fall between this range and not
-
- affect the optimal solution. If the profit per unit later changes to
-
- a value outside this range, the optimal solution will be affected
-
- and you will want to re-optimize the model.
-
-
-
- In the same example, the contribution range for the adjustable
-
- "Italian Sausage" is -‚àû to $1.51. Since the value of the adjustable
-
- is 0.00, Best Answer‚Ñ¢ has determined that it doesn't pay to
-
- produce "Italian Sausage". Therefore, a decrease in the profit
-
- per unit would not affect the optimal solution and is indicated by
-
- negative infinity (-‚àû). On the other hand, an increase to $1.52
-
- or more will change the product mix.
-
-
-
- ______________________________________________
-
- To find the contribution range:
-
-
-
- 1) Select the appropriate Adjustable cell.
-
-
-
- 2) Choose "Contribution Range" from the Optimization menu.
-
- ______________________________________________
-
-